2024-03-05 15:50:51,663 [ 188174 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/_temp/test/git-repo-copy (runner:41, check_args_and_update_paths) 2024-03-05 15:50:51,663 [ 188174 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/_temp/test/git-repo-copy/tests/integration (runner:89, check_args_and_update_paths) 2024-03-05 15:50:51,663 [ 188174 ] INFO : src dir is not set. Will use /home/ubuntu/_work/_temp/test/git-repo-copy/src (runner:96, check_args_and_update_paths) 2024-03-05 15:50:51,663 [ 188174 ] INFO : base_configs_dir: /home/ubuntu/_work/_temp/test/git-repo-copy/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/_temp/test/git-repo-copy/tests/integration (runner:98, check_args_and_update_paths) clickhouse_integration_tests_volume WARNING: Ignoring custom format, because both --format and --quiet are set. Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_jc5bd9 --privileged --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/_temp/test/git-repo-copy/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/_temp/test/git-repo-copy/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/_temp/test/git-repo-copy/src/Server/grpc_protos:/ClickHouse/src/Server/grpc_protos --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e XTABLES_LOCKFILE=/run/host/xtables.lock -e PYTHONUNBUFFERED=1 -e DOCKER_DOTNET_CLIENT_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e DOCKER_HELPER_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e DOCKER_BASE_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e DOCKER_KERBERIZED_HADOOP_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e DOCKER_KERBEROS_KDC_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e DOCKER_MYSQL_JAVA_CLIENT_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e DOCKER_MYSQL_JS_CLIENT_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e DOCKER_MYSQL_PHP_CLIENT_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c -e PYTEST_OPTS='--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_row_policy/test.py::test_throwif_error_in_prewhere_with_same_condition_as_filter test_row_policy/test.py::test_throwif_error_in_where_with_same_condition_as_filter test_row_policy/test.py::test_throwif_in_prewhere_doesnt_expose_restricted_data test_row_policy/test.py::test_throwif_in_where_doesnt_expose_restricted_data test_row_policy/test.py::test_users_xml_is_readonly test_row_policy/test.py::test_with_prewhere test_s3_zero_copy_ttl/test_vertical_merge_memory_usage.py::test_vertical_merge_memory_usage test_settings_constraints_distributed/test.py::test_insert_clamps_settings test_settings_constraints_distributed/test.py::test_select_clamps_settings test_storage_hudi/test.py::test_create_query test_storage_hudi/test.py::test_describe_query test_storage_hudi/test.py::test_select_query test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] test_system_flush_logs/test.py::test_system_logs[system.part_log-1] test_system_flush_logs/test.py::test_system_logs[system.query_log-1] test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] test_system_flush_logs/test.py::test_system_logs[system.text_log-0] test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] test_system_flush_logs/test.py::test_system_logs_non_empty_queue test_system_flush_logs/test.py::test_system_suspend test_system_queries/test.py::test_DROP_DNS_CACHE test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_system_queries/test.py::test_system_flush_logs test_transactions/test.py::test_rollback_unfinished_on_restart1 test_transactions/test.py::test_rollback_unfinished_on_restart2 test_undrop_query/test.py::test_undrop_drop_and_undrop_loop test_user_defined_object_persistence/test.py::test_persistence test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access test_version_update_after_mutation/test.py::test_mutate_and_upgrade test_version_update_after_mutation/test.py::test_upgrade_while_mutation test_zookeeper_config/test_secure.py::test_secure_connection -vvv' altinityinfra/integration-tests-runner:0-19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c '. Start tests ============================= test session starts ============================== platform linux -- Python 3.8.10, pytest-8.0.0, pluggy-1.4.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: repeat-0.9.3, xdist-3.5.0, random-0.2, timeout-2.2.0, order-1.0.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [33 items] scheduling tests via LoadFileScheduling test_system_queries/test.py::test_DROP_DNS_CACHE test_settings_constraints_distributed/test.py::test_insert_clamps_settings test_transactions/test.py::test_rollback_unfinished_on_restart1 test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] test_row_policy/test.py::test_throwif_error_in_prewhere_with_same_condition_as_filter test_version_update_after_mutation/test.py::test_mutate_and_upgrade test_storage_hudi/test.py::test_create_query test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue test_s3_zero_copy_ttl/test_vertical_merge_memory_usage.py::test_vertical_merge_memory_usage test_undrop_query/test.py::test_undrop_drop_and_undrop_loop [gw0] [ 3%] PASSED test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] test_system_flush_logs/test.py::test_system_logs[system.part_log-1] [gw0] [ 6%] PASSED test_system_flush_logs/test.py::test_system_logs[system.part_log-1] test_system_flush_logs/test.py::test_system_logs[system.query_log-1] [gw1] [ 9%] PASSED test_system_queries/test.py::test_DROP_DNS_CACHE test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS [gw0] [ 12%] PASSED test_system_flush_logs/test.py::test_system_logs[system.query_log-1] test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] [gw1] [ 15%] PASSED test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY [gw0] [ 18%] PASSED test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] test_system_flush_logs/test.py::test_system_logs[system.text_log-0] [gw0] [ 21%] PASSED test_system_flush_logs/test.py::test_system_logs[system.text_log-0] test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] [gw0] [ 24%] PASSED test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] test_system_flush_logs/test.py::test_system_logs_non_empty_queue [gw4] [ 27%] PASSED test_storage_hudi/test.py::test_create_query test_storage_hudi/test.py::test_describe_query [gw7] [ 30%] SKIPPED test_s3_zero_copy_ttl/test_vertical_merge_memory_usage.py::test_vertical_merge_memory_usage [gw4] [ 33%] PASSED test_storage_hudi/test.py::test_describe_query test_storage_hudi/test.py::test_select_query [gw0] [ 36%] PASSED test_system_flush_logs/test.py::test_system_logs_non_empty_queue test_system_flush_logs/test.py::test_system_suspend [gw1] [ 39%] PASSED test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_system_queries/test.py::test_system_flush_logs [gw0] [ 42%] PASSED test_system_flush_logs/test.py::test_system_suspend [gw2] [ 45%] PASSED test_row_policy/test.py::test_throwif_error_in_prewhere_with_same_condition_as_filter [gw3] [ 48%] PASSED test_settings_constraints_distributed/test.py::test_insert_clamps_settings test_settings_constraints_distributed/test.py::test_select_clamps_settings [gw1] [ 51%] PASSED test_system_queries/test.py::test_system_flush_logs test_row_policy/test.py::test_throwif_error_in_where_with_same_condition_as_filter [gw4] [ 54%] PASSED test_storage_hudi/test.py::test_select_query [gw6] [ 57%] PASSED test_transactions/test.py::test_rollback_unfinished_on_restart1 test_transactions/test.py::test_rollback_unfinished_on_restart2 [gw2] [ 60%] PASSED test_row_policy/test.py::test_throwif_error_in_where_with_same_condition_as_filter test_row_policy/test.py::test_throwif_in_prewhere_doesnt_expose_restricted_data [gw2] [ 63%] PASSED test_row_policy/test.py::test_throwif_in_prewhere_doesnt_expose_restricted_data test_row_policy/test.py::test_throwif_in_where_doesnt_expose_restricted_data [gw5] [ 66%] PASSED test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue [gw6] [ 69%] PASSED test_transactions/test.py::test_rollback_unfinished_on_restart2 [gw2] [ 72%] PASSED test_row_policy/test.py::test_throwif_in_where_doesnt_expose_restricted_data [gw3] [ 75%] PASSED test_settings_constraints_distributed/test.py::test_select_clamps_settings test_row_policy/test.py::test_users_xml_is_readonly [gw2] [ 78%] PASSED test_row_policy/test.py::test_users_xml_is_readonly test_user_defined_object_persistence/test.py::test_persistence test_row_policy/test.py::test_with_prewhere test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access [gw2] [ 81%] PASSED test_row_policy/test.py::test_with_prewhere [gw8] [ 84%] PASSED test_version_update_after_mutation/test.py::test_mutate_and_upgrade test_version_update_after_mutation/test.py::test_upgrade_while_mutation [gw8] [ 87%] PASSED test_version_update_after_mutation/test.py::test_upgrade_while_mutation [gw6] [ 90%] PASSED test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access test_zookeeper_config/test_secure.py::test_secure_connection [gw3] [ 93%] PASSED test_user_defined_object_persistence/test.py::test_persistence [gw8] [ 96%] PASSED test_zookeeper_config/test_secure.py::test_secure_connection [gw9] [100%] PASSED test_undrop_query/test.py::test_undrop_drop_and_undrop_loop ============================== slowest durations =============================== 127.74s call test_undrop_query/test.py::test_undrop_drop_and_undrop_loop 34.54s setup test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue 28.57s setup test_version_update_after_mutation/test.py::test_mutate_and_upgrade 27.02s call test_zookeeper_config/test_secure.py::test_secure_connection 26.33s setup test_settings_constraints_distributed/test.py::test_insert_clamps_settings 25.81s setup test_row_policy/test.py::test_throwif_error_in_prewhere_with_same_condition_as_filter 24.36s call test_version_update_after_mutation/test.py::test_mutate_and_upgrade 24.19s teardown test_s3_zero_copy_ttl/test_vertical_merge_memory_usage.py::test_vertical_merge_memory_usage 21.79s teardown test_storage_hudi/test.py::test_select_query 21.60s setup test_transactions/test.py::test_rollback_unfinished_on_restart1 21.41s setup test_zookeeper_config/test_secure.py::test_secure_connection 20.41s setup test_s3_zero_copy_ttl/test_vertical_merge_memory_usage.py::test_vertical_merge_memory_usage 20.32s setup test_storage_hudi/test.py::test_create_query 16.97s setup test_undrop_query/test.py::test_undrop_drop_and_undrop_loop 16.54s teardown test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue 16.52s setup test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] 16.08s setup test_system_queries/test.py::test_DROP_DNS_CACHE 15.92s setup test_user_defined_object_persistence/test.py::test_persistence 15.81s call test_user_defined_object_persistence/test.py::test_persistence 13.00s setup test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access 9.95s teardown test_transactions/test.py::test_rollback_unfinished_on_restart2 9.86s call test_version_update_after_mutation/test.py::test_upgrade_while_mutation 9.82s call test_storage_hudi/test.py::test_select_query 9.33s call test_transactions/test.py::test_rollback_unfinished_on_restart1 8.78s call test_transactions/test.py::test_rollback_unfinished_on_restart2 7.31s call test_settings_constraints_distributed/test.py::test_select_clamps_settings 7.20s teardown test_row_policy/test.py::test_with_prewhere 6.85s setup test_settings_constraints_distributed/test.py::test_select_clamps_settings 6.69s call test_system_queries/test.py::test_system_flush_logs 4.63s call test_row_policy/test.py::test_with_prewhere 4.57s teardown test_row_policy/test.py::test_throwif_in_where_doesnt_expose_restricted_data 4.09s call test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue 3.36s teardown test_version_update_after_mutation/test.py::test_upgrade_while_mutation 3.30s teardown test_system_flush_logs/test.py::test_system_suspend 3.29s teardown test_undrop_query/test.py::test_undrop_drop_and_undrop_loop 3.26s teardown test_zookeeper_config/test_secure.py::test_secure_connection 3.22s teardown test_system_queries/test.py::test_system_flush_logs 3.17s call test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access 3.15s call test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 3.06s teardown test_settings_constraints_distributed/test.py::test_select_clamps_settings 2.73s teardown test_row_policy/test.py::test_throwif_error_in_where_with_same_condition_as_filter 2.73s teardown test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access 2.71s teardown test_row_policy/test.py::test_throwif_error_in_prewhere_with_same_condition_as_filter 2.66s call test_settings_constraints_distributed/test.py::test_insert_clamps_settings 2.61s teardown test_row_policy/test.py::test_users_xml_is_readonly 2.51s teardown test_row_policy/test.py::test_throwif_in_prewhere_doesnt_expose_restricted_data 2.48s call test_system_queries/test.py::test_DROP_DNS_CACHE 2.30s call test_system_flush_logs/test.py::test_system_suspend 2.03s call test_row_policy/test.py::test_throwif_in_prewhere_doesnt_expose_restricted_data 1.94s call test_row_policy/test.py::test_throwif_in_where_doesnt_expose_restricted_data 1.64s teardown test_user_defined_object_persistence/test.py::test_persistence 1.28s call test_row_policy/test.py::test_throwif_error_in_prewhere_with_same_condition_as_filter 1.16s call test_row_policy/test.py::test_throwif_error_in_where_with_same_condition_as_filter 0.74s call test_system_flush_logs/test.py::test_system_logs_non_empty_queue 0.60s call test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.57s call test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] 0.52s call test_s3_zero_copy_ttl/test_vertical_merge_memory_usage.py::test_vertical_merge_memory_usage 0.52s setup test_system_flush_logs/test.py::test_system_logs[system.part_log-1] 0.47s call test_system_flush_logs/test.py::test_system_logs[system.text_log-0] 0.47s setup test_system_flush_logs/test.py::test_system_logs[system.query_log-1] 0.47s setup test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] 0.42s call test_row_policy/test.py::test_users_xml_is_readonly 0.42s setup test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] 0.37s call test_storage_hudi/test.py::test_create_query 0.27s call test_storage_hudi/test.py::test_describe_query 0.27s call test_system_flush_logs/test.py::test_system_logs[system.part_log-1] 0.27s call test_system_flush_logs/test.py::test_system_logs[system.query_log-1] 0.22s setup test_system_flush_logs/test.py::test_system_logs[system.text_log-0] 0.22s call test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] 0.22s call test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] 0.00s teardown test_version_update_after_mutation/test.py::test_mutate_and_upgrade 0.00s teardown test_storage_hudi/test.py::test_create_query 0.00s teardown test_transactions/test.py::test_rollback_unfinished_on_restart1 0.00s setup test_storage_hudi/test.py::test_describe_query 0.00s teardown test_system_queries/test.py::test_DROP_DNS_CACHE 0.00s teardown test_settings_constraints_distributed/test.py::test_insert_clamps_settings 0.00s setup test_row_policy/test.py::test_users_xml_is_readonly 0.00s setup test_row_policy/test.py::test_throwif_error_in_where_with_same_condition_as_filter 0.00s setup test_system_flush_logs/test.py::test_system_suspend 0.00s setup test_row_policy/test.py::test_with_prewhere 0.00s setup test_row_policy/test.py::test_throwif_in_prewhere_doesnt_expose_restricted_data 0.00s setup test_row_policy/test.py::test_throwif_in_where_doesnt_expose_restricted_data 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] 0.00s setup test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.text_log-0] 0.00s setup test_system_flush_logs/test.py::test_system_logs_non_empty_queue 0.00s setup test_version_update_after_mutation/test.py::test_upgrade_while_mutation 0.00s teardown test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.00s setup test_system_queries/test.py::test_system_flush_logs 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.part_log-1] 0.00s teardown test_storage_hudi/test.py::test_describe_query 0.00s setup test_storage_hudi/test.py::test_select_query 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.query_log-1] 0.00s setup test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.00s teardown test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.00s setup test_transactions/test.py::test_rollback_unfinished_on_restart2 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] 0.00s teardown test_system_flush_logs/test.py::test_system_logs_non_empty_queue =========================== short test summary info ============================ PASSED test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] PASSED test_system_flush_logs/test.py::test_system_logs[system.part_log-1] PASSED test_system_queries/test.py::test_DROP_DNS_CACHE PASSED test_system_flush_logs/test.py::test_system_logs[system.query_log-1] PASSED test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS PASSED test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] PASSED test_system_flush_logs/test.py::test_system_logs[system.text_log-0] PASSED test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] PASSED test_storage_hudi/test.py::test_create_query PASSED test_storage_hudi/test.py::test_describe_query PASSED test_system_flush_logs/test.py::test_system_logs_non_empty_queue PASSED test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY PASSED test_system_flush_logs/test.py::test_system_suspend PASSED test_row_policy/test.py::test_throwif_error_in_prewhere_with_same_condition_as_filter PASSED test_settings_constraints_distributed/test.py::test_insert_clamps_settings PASSED test_system_queries/test.py::test_system_flush_logs PASSED test_storage_hudi/test.py::test_select_query PASSED test_transactions/test.py::test_rollback_unfinished_on_restart1 PASSED test_row_policy/test.py::test_throwif_error_in_where_with_same_condition_as_filter PASSED test_row_policy/test.py::test_throwif_in_prewhere_doesnt_expose_restricted_data PASSED test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue PASSED test_transactions/test.py::test_rollback_unfinished_on_restart2 PASSED test_row_policy/test.py::test_throwif_in_where_doesnt_expose_restricted_data PASSED test_settings_constraints_distributed/test.py::test_select_clamps_settings PASSED test_row_policy/test.py::test_users_xml_is_readonly PASSED test_row_policy/test.py::test_with_prewhere PASSED test_version_update_after_mutation/test.py::test_mutate_and_upgrade PASSED test_version_update_after_mutation/test.py::test_upgrade_while_mutation PASSED test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access PASSED test_user_defined_object_persistence/test.py::test_persistence PASSED test_zookeeper_config/test_secure.py::test_secure_connection PASSED test_undrop_query/test.py::test_undrop_drop_and_undrop_loop SKIPPED [1] test_s3_zero_copy_ttl/test_vertical_merge_memory_usage.py:29: Disabled for debug and sanitizers. Too slow. ================== 32 passed, 1 skipped in 149.21s (0:02:29) ===================